Excel Cheat Sheet
Central Tendency
\(\rightarrow\) To compute the mean of data use the formula
=AVERAGE([data set])
You can enter [data set] by putting in the range e.g. A2:A16 or just click and highlight all of the data while writing the equation.
\(\rightarrow\) To compute the median of data use the formula
=MEDIAN([data set])
You can enter [data set] by putting in the range e.g. A2:A16 or just click and highlight all of the data while writing the equation.
\(\rightarrow\) To compute the mode of data use the formula
=MODE([data set])
You can enter [data set] by putting in the range e.g. A2:A16 or just click and highlight all of the data while writing the equation.
\(\rightarrow\) To compute the weighted mean of data, first create a column of your data and put the weight in the adjacent column, and you can use the formula
=SUM([data set]*[weight set])/SUM([weight set])
You can enter [data set] and [weight set] by putting in the range e.g. A2:A16 or just click and highlight all of the data while writing the equation.